Creating License Manager Use Reports

• Within Microsoft Access, open the MDB file provided with Sentinel RMS Development Kit: ReportDB.mdb.
• Select the Table tab.
• Click New.
• Select Import Table.
• Select the CSV file you created with lsusage and click Import.

Tip:

In Microsoft Access, not all file types are installed by default. If you do not have the text file type installed, run the Access Setup program, click Add/ Remove, then select Data Access and Change Option to install the text file type.

• The Import Text Wizard is displayed. Continue to click Next until it asks “Where would you like to store your data?”
• Select In an existing table and select the table Lservlog. (If instead of adding to an existing Lservlog table you want to create a new one, delete any rows that are already in the Lservlog table before importing new data.)
• Click Finish. Don’t forget to keep the table name set to Lservlog.

Once the log file use data is imported into the Lservlog table as discussed above, you can now create reports for that data.

1. Within Microsoft Access, open the ReportDB.mdb file. You will immediately see the Sentinel RMS Development Kit report selection screen.
2. You can now select the date range of the report by specifying Start Date and End Date.
3. Now select the type of report you want to create.

The "per user" and "per host" versions of the reports mentioned below also exist.

• Total Tokens Granted Per Feature: This report demonstrates the total number of license tokens granted in the specified date range for each feature.
• Maximum Tokens Granted Per Feature: This report demonstrates the maximum number of token granted for a feature in a single request done specified date range.
• Average Tokens Granted Per Feature: This reports the average number of feature tokens granted for date range on the basis of minutes/hours/days/weeks.
• Total Minutes Used Per Feature:  This report demonstrates the total time (in minutes) each feature was used in the specified date range.
• Total No. Of Tokens Denied Per Feature: This report demonstrates the total number of license tokens for which request was denied in the specified date range.
• Percentage Tokens Denied Per Feature: This report demonstrates the percentage of tokens for which request was denied in the specified date range. This percentage is calculated over total number of tokens requested per feature.

Tip:

When using lsusage to create the CSV file that is the input to these reports, you can limit the data to usage information for specific features and versions.